THE BOSTON CONSULTING GROUP

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text

3 EDA

3.1 management consulting indestry’s yearly new recruit count

3.2 the boston consulting group’s workforce status over the years

4 Workforce sample

4.1 Abhishek Nandi

Job title: Senior associate
Associated: True
Socials: https://linkedin.com/in/abhisheknandi134

4.1.1 Abhishek Nandi’s working period at the boston consulting group

4.1.2 Gantt plot of Abhishek Nandi’s experience

4.2 Akshay Kumar

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/akshay-kumar-37309b18 | https://linkedin.com/in/akshaykumariimbiitd

4.2.1 Akshay Kumar’s working period at the boston consulting group

4.2.2 Gantt plot of Akshay Kumar’s experience

4.3 Alexa Bieler

Job title: Project leader
Associated: False
Socials: https://linkedin.com/in/alexa-bieler-md-230ab58

4.3.1 Alexa Bieler’s working period at the boston consulting group

4.3.2 Gantt plot of Alexa Bieler’s experience

4.4 Alexander Friedhoff

Job title: ****
Associated: False
Socials: https://linkedin.com/in/alexander-cornelius-friedhoff-54024869

4.4.1 Alexander Friedhoff’s working period at the boston consulting group

4.4.2 Gantt plot of Alexander Friedhoff’s experience

4.5 Alexandra Araiza

Job title: Training manager
Associated: False
Socials: https://linkedin.com/in/alexandra-araiza-a1356745

4.5.1 Alexandra Araiza’s working period at the boston consulting group

4.5.2 Gantt plot of Alexandra Araiza’s experience

4.6 Alice Agyiri

Job title: Project leader
Associated: True
Socials: https://linkedin.com/in/alice-agyiri-cfa-73b3b010

4.6.1 Alice Agyiri’s working period at the boston consulting group

4.6.2 Gantt plot of Alice Agyiri’s experience

4.7 Amit Goswami

Job title: People and organization expert
Associated: True
Socials: https://twitter.com/amitgos82 | https://linkedin.com/in/goswamiamit

4.7.1 Amit Goswami’s working period at the boston consulting group

4.7.2 Gantt plot of Amit Goswami’s experience

4.8 Anchal Agrawal

Job title: Senior associate
Associated: True
Socials: https://linkedin.com/in/anchal-agrawal-a5615628

4.8.1 Anchal Agrawal’s working period at the boston consulting group

4.8.2 Gantt plot of Anchal Agrawal’s experience

4.9 Anda-Cristina Radu

Job title: Associate
Associated: True
Socials: https://linkedin.com/in/anda-cristina-radu-23b64b22 | https://linkedin.com/in/anda-radu-23b64b22

4.9.1 Anda-Cristina Radu’s working period at the boston consulting group

4.9.2 Gantt plot of Anda-Cristina Radu’s experience

4.10 Andreas Klar

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/dr-andreas-klar-mba-a8b237 | https://linkedin.com/in/andreas-klar-mba-a8b237 | https://linkedin.com/in/andreas-klar-a8b237

4.10.1 Andreas Klar’s working period at the boston consulting group

4.10.2 Gantt plot of Andreas Klar’s experience

4.11 Andy Kurtzman

Job title: Talent acquisition lead
Associated: True
Socials: https://linkedin.com/in/andy-kurtzman-50ba281 | https://linkedin.com/in/andykurtzman

4.11.1 Andy Kurtzman’s working period at the boston consulting group

4.11.2 Gantt plot of Andy Kurtzman’s experience

4.12 Animesh Kumar

Job title: Team manager, knowledge curation team
Associated: True
Socials: https://linkedin.com/in/animesh-kumar-80449493

4.12.1 Animesh Kumar’s working period at the boston consulting group

4.12.2 Gantt plot of Animesh Kumar’s experience

4.13 Axel Adida

Job title: Senior advisor
Associated: True
Socials: https://twitter.com/axeladida | https://linkedin.com/in/axel-adida-552a561 | https://facebook.com/axel.adida | https://angel.co/axel-adida | https://klout.com/axeladida | https://youtube.com/user/adieuaberlin | https://foursquare.com/user/641554

4.13.1 Axel Adida’s working period at the boston consulting group

4.13.2 Gantt plot of Axel Adida’s experience

4.14 Benjamin Keppler

Job title: Associate
Associated: True
Socials: https://linkedin.com/in/benjamin-keppler-6b103057 | https://linkedin.com/in/benjamin-keppler

4.14.1 Benjamin Keppler’s working period at the boston consulting group

4.14.2 Gantt plot of Benjamin Keppler’s experience

4.15 Bill Young

Job title: Project leader
Associated: True
Socials: https://linkedin.com/in/bill-young-7b81205

4.15.1 Bill Young’s working period at the boston consulting group

4.15.2 Gantt plot of Bill Young’s experience

4.16 Carsten Schaetzberger

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/carsten-schaetzberger-150b63

4.16.1 Carsten Schaetzberger’s working period at the boston consulting group

4.16.2 Gantt plot of Carsten Schaetzberger’s experience

4.17 Christian Adler

Job title: Associate director digital transformation
Associated: True
Socials: https://linkedin.com/in/christianadler | https://twitter.com/christianjadler | https://linkedin.com/in/christian-adler-9312b3

4.17.1 Christian Adler’s working period at the boston consulting group

4.17.2 Gantt plot of Christian Adler’s experience

4.18 Cristiano Rizzi

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/cristiano-rizzi-549658

4.18.1 Cristiano Rizzi’s working period at the boston consulting group

4.18.2 Gantt plot of Cristiano Rizzi’s experience

4.19 Daniel Welberts

Job title: Consultant
Associated: False
Socials: https://linkedin.com/in/daniel-welberts-7345a223 | https://linkedin.com/in/anonym-anonym-7345a223

4.19.1 Daniel Welberts’s working period at the boston consulting group

4.19.2 Gantt plot of Daniel Welberts’s experience

4.20 David Hirsch

Job title: Project leader
Associated: True
Socials: https://linkedin.com/in/david-hirsch-8bb80736

4.20.1 David Hirsch’s working period at the boston consulting group

4.20.2 Gantt plot of David Hirsch’s experience

4.21 David Panhans

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/david-panhans-85194b

4.21.1 David Panhans’s working period at the boston consulting group

4.21.2 Gantt plot of David Panhans’s experience

4.22 Ekaterina Sycheva

Job title: Principal
Associated: True
Socials: https://linkedin.com/in/ekaterina-sycheva-1183b5

4.22.1 Ekaterina Sycheva’s working period at the boston consulting group

4.22.2 Gantt plot of Ekaterina Sycheva’s experience

4.23 Elijah Kim

4.23.1 Elijah Kim’s working period at the boston consulting group

4.23.2 Gantt plot of Elijah Kim’s experience

4.24 Emily Ellis

Job title: Head of pricing, bcg omnia
Associated: True
Socials: https://linkedin.com/in/emily-ellis-b4b0594 | https://linkedin.com/in/emilyeileen

4.24.1 Emily Ellis’s working period at the boston consulting group

4.24.2 Gantt plot of Emily Ellis’s experience

4.25 Esra Unluaslan

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/esra-unluaslan-637a218

4.25.1 Esra Unluaslan’s working period at the boston consulting group

4.25.2 Gantt plot of Esra Unluaslan’s experience

4.26 Florian Deutzmann

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/floriandeutzmann | https://twitter.com/fdeutzmann

4.26.1 Florian Deutzmann’s working period at the boston consulting group

4.26.2 Gantt plot of Florian Deutzmann’s experience

4.27 Franziska Weis

Job title: Associate
Associated: True
Socials: https://linkedin.com/in/franziska-weis-31684452

4.27.1 Franziska Weis’s working period at the boston consulting group

4.27.2 Gantt plot of Franziska Weis’s experience

4.28 Hadi Hassan

Job title: Principal
Associated: True
Socials: https://linkedin.com/in/hadi-el-hassan-96255125 | https://facebook.com/hadi.elhassan

4.28.1 Hadi Hassan’s working period at the boston consulting group

4.28.2 Gantt plot of Hadi Hassan’s experience

4.29 Hamid Maher

Job title: Managing director and partner
Associated: True
Socials: https://linkedin.com/in/hamid-maher-83a5033

4.29.1 Hamid Maher’s working period at the boston consulting group

4.29.2 Gantt plot of Hamid Maher’s experience

4.30 Hauke Brede

Job title: Senior advisor
Associated: True
Socials: https://linkedin.com/in/hauke-brede-dr-4366bb

4.30.1 Hauke Brede’s working period at the boston consulting group

4.30.2 Gantt plot of Hauke Brede’s experience

4.31 Jacqueline Govers

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/jacqueline-govers-a9b97a1

4.31.1 Jacqueline Govers’s working period at the boston consulting group

4.31.2 Gantt plot of Jacqueline Govers’s experience

4.32 Jimmy Feng

Job title: Partner
Associated: True
Socials: https://facebook.com/jimmyfeng80 | https://linkedin.com/in/jimmyfeng

4.32.1 Jimmy Feng’s working period at the boston consulting group

4.32.2 Gantt plot of Jimmy Feng’s experience

4.33 Jonas Haraldsson

Job title: Incoming associate
Associated: True
Socials: https://linkedin.com/in/jonas-haraldsson-14050b66

4.33.1 Jonas Haraldsson’s working period at the boston consulting group

4.33.2 Gantt plot of Jonas Haraldsson’s experience

4.34 Jonathan Harmon

Job title: Summer consultant
Associated: False
Socials: https://linkedin.com/in/jonathanwharmon | https://linkedin.com/in/jonathan-westleigh-harmon-a276424 | https://facebook.com/jonathanwharmon

4.34.1 Jonathan Harmon’s working period at the boston consulting group

4.34.2 Gantt plot of Jonathan Harmon’s experience

4.35 Jônathas Alverne

Job title: Senior associate
Associated: False
Socials: https://linkedin.com/in/jônathas-alverne-59a5358

4.35.1 Jônathas Alverne’s working period at the boston consulting group

4.35.2 Gantt plot of Jônathas Alverne’s experience

4.36 Kaustubh Wagle

Job title: Partner
Associated: True
Socials: https://linkedin.com/in/kaustubh-wagle-723b492 | https://youtube.com/user/kdwagle | https://facebook.com/kdwagle

4.36.1 Kaustubh Wagle’s working period at the boston consulting group

4.36.2 Gantt plot of Kaustubh Wagle’s experience

4.37 Lani Ma

Job title: Part time assistant
Associated: True
Socials: https://linkedin.com/in/amazinglani | https://linkedin.com/in/lanima

4.37.1 Lani Ma’s working period at the boston consulting group

4.37.2 Gantt plot of Lani Ma’s experience

4.38 Li Yang

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/li-yang-18b5322

4.38.1 Li Yang’s working period at the boston consulting group

4.38.2 Gantt plot of Li Yang’s experience

4.39 Lissa Filose

Job title: North america diversity and inclusion, women@bcg
Associated: True
Socials: https://linkedin.com/in/lissafilose | https://linkedin.com/in/lissa-wilson-filose-69b1382

4.39.1 Lissa Filose’s working period at the boston consulting group

4.39.2 Gantt plot of Lissa Filose’s experience

4.40 Michael Kim

Job title: Associate
Associated: True
Socials: https://linkedin.com/in/michaelryankim

4.40.1 Michael Kim’s working period at the boston consulting group

4.40.2 Gantt plot of Michael Kim’s experience

4.41 Mustafa Bosca

Job title: Managing director and partner
Associated: True
Socials: https://linkedin.com/in/mustafa-serdar-bosca-762b842

4.41.1 Mustafa Bosca’s working period at the boston consulting group

4.41.2 Gantt plot of Mustafa Bosca’s experience

4.42 Nanna Lingegård

Job title: Visiting associate
Associated: False
Socials: https://linkedin.com/in/nannalingegard

4.42.1 Nanna Lingegård’s working period at the boston consulting group

4.42.2 Gantt plot of Nanna Lingegård’s experience

4.43 Nate Lee

Job title: Summer intern
Associated: False
Socials: https://linkedin.com/in/nate-m-lee-907692bb

4.43.1 Nate Lee’s working period at the boston consulting group

4.43.2 Gantt plot of Nate Lee’s experience

4.44 Nicolas Weber

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/nicolas-weber-81074142 | https://linkedin.com/in/nicolasweber9

4.44.1 Nicolas Weber’s working period at the boston consulting group

4.44.2 Gantt plot of Nicolas Weber’s experience

4.45 Paige Jackson

Job title: Knowledge analyst
Associated: True
Socials: https://linkedin.com/in/paigerjackson

4.45.1 Paige Jackson’s working period at the boston consulting group

4.45.2 Gantt plot of Paige Jackson’s experience

4.46 Peter Burggraaff

Job title: Partner and director - digital and technology in retail
Associated: True
Socials: https://linkedin.com/in/peterburggraaff | https://linkedin.com/in/peter-burggraaff-a78370 | https://twitter.com/peterburggraaff | https://facebook.com/pburggraaff

4.46.1 Peter Burggraaff’s working period at the boston consulting group

4.46.2 Gantt plot of Peter Burggraaff’s experience

4.47 Rien Kamman

Job title: Principal
Associated: True
Socials: https://linkedin.com/in/rien-kamman-39489510 | https://linkedin.com/in/rienkamman

4.47.1 Rien Kamman’s working period at the boston consulting group

4.47.2 Gantt plot of Rien Kamman’s experience

4.48 Ronald Lee

Job title: Recruiter- digitalbcg
Associated: True
Socials: https://linkedin.com/in/ronlee6 | https://facebook.com/ronald.lee.906

4.48.1 Ronald Lee’s working period at the boston consulting group

4.48.2 Gantt plot of Ronald Lee’s experience

4.49 Sara Roedner

Job title: Project leader
Associated: False
Socials: https://linkedin.com/in/sroedner

4.49.1 Sara Roedner’s working period at the boston consulting group

4.49.2 Gantt plot of Sara Roedner’s experience

4.50 Sergey Ishkov

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/sergeyishkov

4.50.1 Sergey Ishkov’s working period at the boston consulting group

4.50.2 Gantt plot of Sergey Ishkov’s experience

4.51 Seyed Mousavi

Job title: Data scientist and consultant
Associated: True
Socials: https://linkedin.com/in/seyed-ali-mousavi-b9722028

4.51.1 Seyed Mousavi’s working period at the boston consulting group

4.51.2 Gantt plot of Seyed Mousavi’s experience

4.52 Stéphane Biso

Job title: Principal - program director - bi, crm, data
Associated: False
Socials: https://linkedin.com/in/stéphane-biso-65bb1893

4.52.1 Stéphane Biso’s working period at the boston consulting group

4.52.2 Gantt plot of Stéphane Biso’s experience

4.53 Tamer Obied

Job title: Managing director and partner
Associated: True
Socials: https://linkedin.com/in/tamer-m-obied-08b1062 | https://angel.co/tamer-obied | https://facebook.com/tamerobied

4.53.1 Tamer Obied’s working period at the boston consulting group

4.53.2 Gantt plot of Tamer Obied’s experience

4.54 Thomas Jensen

Job title: Senior partner, managing director
Associated: True
Socials: https://linkedin.com/in/thomas-jensen-1295561

4.54.1 Thomas Jensen’s working period at the boston consulting group

4.54.2 Gantt plot of Thomas Jensen’s experience

4.55 Thomas Knappitsch

Job title: Associate
Associated: True
Socials: https://linkedin.com/in/thomas-knappitsch-483b62a3 | https://linkedin.com/in/tknappitsch | https://twitter.com/knappowitsch | https://facebook.com/thomas.knappitsch.5

4.55.1 Thomas Knappitsch’s working period at the boston consulting group

4.55.2 Gantt plot of Thomas Knappitsch’s experience

4.56 Thorben Scheidegger

Job title: Principal
Associated: True
Socials: https://youtube.com/user/uctzwcy8uyz_mcxgrtbnflfw | https://linkedin.com/in/thorbenscheidegger

4.56.1 Thorben Scheidegger’s working period at the boston consulting group

4.56.2 Gantt plot of Thorben Scheidegger’s experience

4.57 Til Klein

Job title: Partner and managing director
Associated: True
Socials: https://linkedin.com/in/til-klein-4b412697

4.57.1 Til Klein’s working period at the boston consulting group

4.57.2 Gantt plot of Til Klein’s experience

4.58 Toshihisa Hirano

Job title: Principal
Associated: True
Socials: https://linkedin.com/in/toshihisa-hirano-bb5036138

4.58.1 Toshihisa Hirano’s working period at the boston consulting group

4.58.2 Gantt plot of Toshihisa Hirano’s experience

4.59 Wallrick Williams

Job title: Principal
Associated: True
Socials: https://linkedin.com/in/wallrick-williams-65726a3 | https://facebook.com/wallrick | https://linkedin.com/in/wallrickwilliams

4.59.1 Wallrick Williams’s working period at the boston consulting group

4.59.2 Gantt plot of Wallrick Williams’s experience

4.60 Wendy Lei

Job title: Consultant
Associated: True
Socials: https://linkedin.com/in/wendy-lei-a356372b | https://linkedin.com/in/wendy-lei-rossmba